﻿CREATE TABLE [dbo].[Servico] (
    [CodServico]             INT          IDENTITY (1, 1) NOT NULL,
    [CodCliente]             INT          NOT NULL,
    [Tipo]                   VARCHAR (50) NOT NULL,
    [Marca]                  VARCHAR (50) NOT NULL,
    [Modelo]                 VARCHAR (50) NOT NULL,
    [Defeito]                NTEXT        NULL,
    [Acoes]                  NTEXT        NULL,
    [Orcamento]              INT          NULL,
    [Pago]                   BIT          DEFAULT ((0)) NOT NULL,
    [Situacao]               VARCHAR (20) NULL,
    [SituacaoOrcamento]      DATETIME     NULL,
    [SituacaoCancelado]      DATETIME     NULL,
    [SituacaoEsperandoPecas] DATETIME     NULL,
    [SituacaoAprovado]       DATETIME     NULL,
    [SituacaoPronto]         DATETIME     NULL,
    [SituacaoEntregue]       DATETIME     NULL,
    [Observacoes]            NTEXT        NULL
);

